CREATE EXTERNAL TABLE `hdp_lbg_supin_zplisting.app_zp_wb_n_flow_action_cube`(
  `source1` string COMMENT '同城宝流量来源一级',
  `platform` string COMMENT '平台类型',
  `slot` string COMMENT '推荐位标识',
  `disp_local1` string COMMENT '一级展现地域',
  `disp_cate2` string COMMENT '二级展现类别',
  `sellingcitytag` string COMMENT '城市类型',
  `requesttype` string COMMENT '请求商业类型',
  `search_pos` string COMMENT '帖子相对位置序号',
  `info_buid_type` string COMMENT '帖子发布用户类型',
  `info_local1` string COMMENT '职位一级发布地域',
  `info_cate2` string COMMENT '职位二级类别',
  `search_pv` bigint COMMENT '检索pv',
  `search_epv` bigint COMMENT '检索epv',
  `search_as` bigint COMMENT '检索as',
  `search_uv` bigint COMMENT '检索uv',
  `search_infocnt` bigint COMMENT '检索出职位数',
  `search_busercnt` bigint COMMENT '检索出b端用户数',
  `search_comcnt` bigint COMMENT '检索出企业数',
  `exp_as` bigint COMMENT '真实曝光as',
  `exp_uv` bigint COMMENT '真实曝光uv',
  `exp_epv` bigint COMMENT '真实曝光epv',
  `exp_busercnt` bigint COMMENT '真实曝光B端用户数',
  `exp_infocnt` bigint COMMENT '真实曝光职位数',
  `exp_comcnt` bigint COMMENT '曝光出企业数',
  `click_cnt` bigint COMMENT '详情页点击数',
  `click_uv` bigint COMMENT '详情页点击uv',
  `click_as` bigint COMMENT '详情页点击as',
  `click_epv` bigint COMMENT '详情页点击epv',
  `click_infocnt` bigint COMMENT '详情页点击职位数',
  `click_comcnt` bigint COMMENT '详情页点击企业数',
  `click_busercnt` bigint COMMENT '详情页点击B侧用户数',
  `delivery_cnt` bigint COMMENT '投递量',
  `delivery_epv` bigint COMMENT '有投递epv',
  `delivery_as` bigint COMMENT '有投递as',
  `delivery_uv` bigint COMMENT '投递uv',
  `devresume_cnt` bigint COMMENT '投递简历量',
  `delivery_infocnt` bigint COMMENT '获得投递职位量',
  `delivery_comcnt` bigint COMMENT '获得投递企业量',
  `delivery_busercnt` bigint COMMENT '获得投递b端用户量',
  `im_cnt` bigint COMMENT '发起会话量',
  `im_ack_cnt` bigint COMMENT '触达会话量',
  `im_read_cnt` bigint COMMENT '阅读会话量',
  `im_reply_cnt` bigint COMMENT '回复会话量',
  `im_epv` bigint COMMENT '会话epv',
  `im_as` bigint COMMENT '会话as',
  `im_uv` bigint COMMENT '会话uv',
  `im_infocnt` bigint COMMENT '会话职位量',
  `im_comcnt` bigint COMMENT '会话企业量',
  `im_busercnt` bigint COMMENT '会话b端用户量',
  `tel_cnt` bigint COMMENT '电话拨打量',
  `tel_conn_cnt` bigint COMMENT '电话接通量',
  `tel_epv` bigint COMMENT '电话epv',
  `tel_as` bigint COMMENT '电话as',
  `tel_uv` bigint COMMENT '电话uv',
  `tel_infocnt` bigint COMMENT '电话职位量',
  `tel_comcnt` bigint COMMENT '电话企业量',
  `tel_busercnt` bigint COMMENT '电话b端用户量',
  `link_cnt` bigint COMMENT '连接量',
  `link_bcuv` bigint COMMENT '连接B-C用户量',
  `link_uv` bigint COMMENT '连接uv',
  `link_infocnt` bigint COMMENT '连接职位量',
  `link_comcnt` bigint COMMENT '连接企业量',
  `link_busercnt` bigint COMMENT '连接b端用户量',
  `jz_cost` bigint COMMENT '黄金展位扣费总金额（万分之一元）',
  `jz_cash` bigint COMMENT '黄金展位扣费现金（万分之一元）',
  `yx_cost` bigint COMMENT '优选扣费总金额（万分之一元）',
  `yx_cash` bigint COMMENT '优选扣费现金（万分之一元）',
  `dimension` string COMMENT '维度组合',
  `dimension_value` string COMMENT '维度值组合',
  `new_info_cate2` string COMMENT '新归属二级类目',
  `new_info_cate3` string COMMENT '新归属三级类目')
COMMENT '58多维计算结果表(串联)-动作'
PARTITIONED BY (
  `dt` string COMMENT '日期分区',
  `action` string COMMENT '动作')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'viewfs://58-cluster/home/hdp_lbg_supin/resultdata/offline_warehouse3/wb/app/app_zp_wb_n_flow_action_cube'
;